{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys; sys.path.append(\"C:/GitWorks/pdb-profiling\")\n",
    "from pdb_profiling.fetcher.dbfetch import Neo4j\n",
    "from pdb_profiling.processers.pdbe.neo4j_api import Neo4j_API, Entry, SIFTS\n",
    "from pdb_profiling.commands.interface import init_semaphore\n",
    "import logging\n",
    "from unsync import unsync\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Conntect to remote/local `Neo4j` DataBase (PDBe Graph DataBase)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "config = {\n",
    "        'user': 'your username', \n",
    "        'pass': 'your password',\n",
    "        'url': 'your local neo4j db'\n",
    "        }\n",
    "\n",
    "Neo4j_API.neo4j_api = Neo4j(\n",
    "        config=config,\n",
    "        semaphore=init_semaphore(10).result(),\n",
    "        log_func=logging.info).connnect().result()\n",
    "neo4j_api = Neo4j_API.neo4j_api"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Simple Function that Retrieving Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_info(neo4j_api, func, **kwargs):\n",
    "    query, newkwargs = func(**kwargs)\n",
    "    res = neo4j_api.afetch(query, **newkwargs).result()\n",
    "    return Entry.to_data_frame(res)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "  pdb_id PDB_REV_DATE_ORIGINAL       FIRST_REV_DATE         PDB_REV_DATE  \\\n0   1a01   1997-12-08 00:00:00  1998-03-18 00:00:00  2011-07-13 00:00:00   \n1   2xyn   2010-11-18 00:00:00  2010-12-01 00:00:00  2019-04-03 00:00:00   \n\n         REVISION_DATE  resolution METHOD_CLASS  \n0  2011-07-13 00:00:00        1.80        x-ray  \n1  2019-04-03 00:00:00        2.81        x-ray  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>pdb_id</th>\n      <th>PDB_REV_DATE_ORIGINAL</th>\n      <th>FIRST_REV_DATE</th>\n      <th>PDB_REV_DATE</th>\n      <th>REVISION_DATE</th>\n      <th>resolution</th>\n      <th>METHOD_CLASS</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>1a01</td>\n      <td>1997-12-08 00:00:00</td>\n      <td>1998-03-18 00:00:00</td>\n      <td>2011-07-13 00:00:00</td>\n      <td>2011-07-13 00:00:00</td>\n      <td>1.80</td>\n      <td>x-ray</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2xyn</td>\n      <td>2010-11-18 00:00:00</td>\n      <td>2010-12-01 00:00:00</td>\n      <td>2019-04-03 00:00:00</td>\n      <td>2019-04-03 00:00:00</td>\n      <td>2.81</td>\n      <td>x-ray</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 4
    }
   ],
   "source": [
    "get_info(neo4j_api, Entry.summary_method, pdbs=['1a01', '2xyn'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "      UniProt pdb_id entity_id chain_id  identity    pdb_range     unp_range\n0      P68871   1a01         2        D  0.986301   [[1, 146]]    [[2, 147]]\n1      P68871   1a01         2        B  0.986301   [[1, 146]]    [[2, 147]]\n2      P69905   1a01         1        A  1.000000   [[1, 141]]    [[2, 142]]\n3      P69905   1a01         1        C  1.000000   [[1, 141]]    [[2, 142]]\n4   P42684-10   2xyn         1        C  0.992593  [[25, 292]]  [[264, 531]]\n5    P42684-6   2xyn         1        B  0.992593  [[25, 292]]  [[258, 525]]\n6    P42684-2   2xyn         1        B  0.992593  [[25, 292]]  [[243, 510]]\n7      P42684   2xyn         1        B  0.992593  [[25, 292]]  [[279, 546]]\n8    P42684-7   2xyn         1        A  0.992593  [[25, 292]]  [[258, 525]]\n9    P42684-4   2xyn         1        C  0.992593  [[25, 292]]  [[243, 510]]\n10   P42684-4   2xyn         1        B  0.992593  [[25, 292]]  [[243, 510]]\n11   P42684-7   2xyn         1        C  0.992593  [[25, 292]]  [[258, 525]]\n12   P42684-5   2xyn         1        C  0.992593  [[25, 292]]  [[279, 546]]\n13   P42684-3   2xyn         1        A  0.992593  [[25, 292]]  [[264, 531]]\n14  P42684-10   2xyn         1        A  0.992593  [[25, 292]]  [[264, 531]]\n15   P42684-6   2xyn         1        C  0.992593  [[25, 292]]  [[258, 525]]\n16   P42684-5   2xyn         1        B  0.992593  [[25, 292]]  [[279, 546]]\n17   P42684-3   2xyn         1        C  0.992593  [[25, 292]]  [[264, 531]]\n18   P42684-2   2xyn         1        C  0.992593  [[25, 292]]  [[243, 510]]\n19   P42684-2   2xyn         1        A  0.992593  [[25, 292]]  [[243, 510]]\n20     P42684   2xyn         1        C  0.992593  [[25, 292]]  [[279, 546]]\n21   P42684-8   2xyn         1        B  0.992593  [[25, 292]]  [[258, 525]]\n22  P42684-10   2xyn         1        B  0.992593  [[25, 292]]  [[264, 531]]\n23   P42684-8   2xyn         1        A  0.992593  [[25, 292]]  [[258, 525]]\n24     P42684   2xyn         1        A  0.992593  [[25, 292]]  [[279, 546]]\n25   P42684-8   2xyn         1        C  0.992593  [[25, 292]]  [[258, 525]]\n26   P42684-3   2xyn         1        B  0.992593  [[25, 292]]  [[264, 531]]\n27   P42684-6   2xyn         1        A  0.992593  [[25, 292]]  [[258, 525]]\n28   P42684-5   2xyn         1        A  0.992593  [[25, 292]]  [[279, 546]]\n29   P42684-7   2xyn         1        B  0.992593  [[25, 292]]  [[258, 525]]\n30   P42684-4   2xyn         1        A  0.992593  [[25, 292]]  [[243, 510]]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>UniProt</th>\n      <th>pdb_id</th>\n      <th>entity_id</th>\n      <th>chain_id</th>\n      <th>identity</th>\n      <th>pdb_range</th>\n      <th>unp_range</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>P68871</td>\n      <td>1a01</td>\n      <td>2</td>\n      <td>D</td>\n      <td>0.986301</td>\n      <td>[[1, 146]]</td>\n      <td>[[2, 147]]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>P68871</td>\n      <td>1a01</td>\n      <td>2</td>\n      <td>B</td>\n      <td>0.986301</td>\n      <td>[[1, 146]]</td>\n      <td>[[2, 147]]</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>P69905</td>\n      <td>1a01</td>\n      <td>1</td>\n      <td>A</td>\n      <td>1.000000</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>P69905</td>\n      <td>1a01</td>\n      <td>1</td>\n      <td>C</td>\n      <td>1.000000</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>P42684-10</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[264, 531]]</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>P42684-6</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>P42684-2</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[243, 510]]</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>P42684</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[279, 546]]</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>P42684-7</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>P42684-4</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[243, 510]]</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>P42684-4</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[243, 510]]</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>P42684-7</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>P42684-5</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[279, 546]]</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>P42684-3</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[264, 531]]</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>P42684-10</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[264, 531]]</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>P42684-6</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>P42684-5</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[279, 546]]</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>P42684-3</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[264, 531]]</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>P42684-2</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[243, 510]]</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>P42684-2</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[243, 510]]</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>P42684</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[279, 546]]</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>P42684-8</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>P42684-10</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[264, 531]]</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>P42684-8</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>P42684</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[279, 546]]</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>P42684-8</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>P42684-3</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[264, 531]]</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>P42684-6</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>P42684-5</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[279, 546]]</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>P42684-7</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>P42684-4</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[243, 510]]</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 5
    }
   ],
   "source": [
    "get_info(neo4j_api, SIFTS.summary_mapping, lyst=['1a01', '2xyn'], id_type='pdb')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "      UniProt pdb_id entity_id chain_id  identity    pdb_range      unp_range\n0    P42684-7   3gvu         1        A  0.992593  [[25, 292]]   [[258, 525]]\n1    P42684-7   5np5         1        A  1.000000    [[5, 61]]    [[89, 145]]\n2    P42684-7   5np5         1        B  1.000000    [[5, 61]]    [[89, 145]]\n3    P42684-7   2kk1         1        A  0.992000  [[11, 135]]  [[934, 1058]]\n4    P42684-7   3hmi         1        A  0.992593  [[25, 292]]   [[258, 525]]\n..        ...    ...       ...      ...       ...          ...            ...\n591    P69905   1o1o         1        A  0.985816   [[1, 141]]     [[2, 142]]\n592    P69905   1lfz         1        A  1.000000   [[1, 141]]     [[2, 142]]\n593    P69905   3ovu         3        C  1.000000   [[1, 141]]     [[2, 142]]\n594    P69905   1qxd         1        C  1.000000   [[1, 141]]     [[2, 142]]\n595    P69905   1qxd         1        A  1.000000   [[1, 141]]     [[2, 142]]\n\n[596 rows x 7 columns]",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>UniProt</th>\n      <th>pdb_id</th>\n      <th>entity_id</th>\n      <th>chain_id</th>\n      <th>identity</th>\n      <th>pdb_range</th>\n      <th>unp_range</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>P42684-7</td>\n      <td>3gvu</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>P42684-7</td>\n      <td>5np5</td>\n      <td>1</td>\n      <td>A</td>\n      <td>1.000000</td>\n      <td>[[5, 61]]</td>\n      <td>[[89, 145]]</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>P42684-7</td>\n      <td>5np5</td>\n      <td>1</td>\n      <td>B</td>\n      <td>1.000000</td>\n      <td>[[5, 61]]</td>\n      <td>[[89, 145]]</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>P42684-7</td>\n      <td>2kk1</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992000</td>\n      <td>[[11, 135]]</td>\n      <td>[[934, 1058]]</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>P42684-7</td>\n      <td>3hmi</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25, 292]]</td>\n      <td>[[258, 525]]</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>591</th>\n      <td>P69905</td>\n      <td>1o1o</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.985816</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n    <tr>\n      <th>592</th>\n      <td>P69905</td>\n      <td>1lfz</td>\n      <td>1</td>\n      <td>A</td>\n      <td>1.000000</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n    <tr>\n      <th>593</th>\n      <td>P69905</td>\n      <td>3ovu</td>\n      <td>3</td>\n      <td>C</td>\n      <td>1.000000</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n    <tr>\n      <th>594</th>\n      <td>P69905</td>\n      <td>1qxd</td>\n      <td>1</td>\n      <td>C</td>\n      <td>1.000000</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n    <tr>\n      <th>595</th>\n      <td>P69905</td>\n      <td>1qxd</td>\n      <td>1</td>\n      <td>A</td>\n      <td>1.000000</td>\n      <td>[[1, 141]]</td>\n      <td>[[2, 142]]</td>\n    </tr>\n  </tbody>\n</table>\n<p>596 rows × 7 columns</p>\n</div>"
     },
     "metadata": {},
     "execution_count": 6
    }
   ],
   "source": [
    "get_info(neo4j_api, SIFTS.summary_mapping, lyst=['P42684-7', 'P69905'], id_type='unp')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Retrieve Handled Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "@unsync\n",
    "async def get_ed_sifts_info(neo4j_api, **kwargs):\n",
    "    query, newkwargs = SIFTS.summary_mapping(**kwargs)\n",
    "    res = await neo4j_api.afetch(query, **newkwargs)\n",
    "    res = await SIFTS.deal_mapping(res, neo4j_api)\n",
    "    return res"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "text": "Wall time: 0 ns\n"
    },
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": "           [[1,2549]]   \n20                                [[1,155],[158,291]]   \n21                                [[1,155],[158,291]]   \n22                                [[1,155],[158,291]]   \n23                                [[1,155],[158,291]]   \n24                                          [[1,146]]   \n25                                          [[1,146]]   \n26                                          [[1,141]]   \n27                                          [[1,141]]   \n28                                         [[25,292]]   \n29                                         [[25,292]]   \n30                                         [[25,292]]   \n31                                         [[25,292]]   \n32                                         [[25,292]]   \n33                                         [[25,292]]   \n34                                         [[25,292]]   \n35                                         [[25,292]]   \n36                                         [[25,292]]   \n37                                         [[25,292]]   \n38                                         [[25,292]]   \n39                                         [[25,292]]   \n40                                         [[25,292]]   \n41                                         [[25,292]]   \n42                                         [[25,292]]   \n43                                         [[25,292]]   \n44                                         [[25,292]]   \n45                                         [[25,292]]   \n46                                         [[25,292]]   \n47                                         [[25,292]]   \n48                                         [[25,292]]   \n49                                         [[25,292]]   \n50                                         [[25,292]]   \n51                                         [[25,292]]   \n52                                         [[25,292]]   \n53                                         [[25,292]]   \n54                                         [[25,292]]   \n\n                                            unp_range  group_info  \\\n0                                           [[1,184]]           1   \n1                                           [[1,184]]           1   \n2                                           [[1,118]]           1   \n3                                           [[1,118]]           1   \n4   [[2,379],[151,169],[170,176],[177,186],[187,19...           7   \n5                                [[2,503],[504,1177]]           2   \n6   [[2,379],[151,169],[170,176],[177,186],[187,19...           7   \n7                                [[2,503],[504,1177]]           2   \n8                                          [[2,1335]]           1   \n9                                          [[2,1335]]           1   \n10                                  [[1,43],[44,325]]           2   \n11                                          [[1,260]]           1   \n12                                  [[1,43],[44,325]]           2   \n13                                          [[1,260]]           1   \n14                                          [[1,326]]           1   \n15                                         [[20,210]]           1   \n16                                         [[20,210]]           1   \n17                                          [[1,326]]           1   \n18                                         [[1,2549]]           1   \n19                                         [[1,2549]]           1   \n20                                [[1,155],[184,317]]           2   \n21                                [[1,155],[226,359]]           2   \n22                                [[1,155],[226,359]]           2   \n23                                [[1,155],[184,317]]           2   \n24                                          [[2,147]]           1   \n25                                          [[2,147]]           1   \n26                                          [[2,142]]           1   \n27                                          [[2,142]]           1   \n28                                        [[264,531]]           1   \n29                                        [[258,525]]           1   \n30                                        [[243,510]]           1   \n31                                        [[279,546]]           1   \n32                                        [[258,525]]           1   \n33                                        [[243,510]]           1   \n34                                        [[243,510]]           1   \n35                                        [[258,525]]           1   \n36                                        [[279,546]]           1   \n37                                        [[264,531]]           1   \n38                                        [[264,531]]           1   \n39                                        [[258,525]]           1   \n40                                        [[279,546]]           1   \n41                                        [[264,531]]           1   \n42                                        [[243,510]]           1   \n43                                        [[243,510]]           1   \n44                                        [[279,546]]           1   \n45                                        [[258,525]]           1   \n46                                        [[264,531]]           1   \n47                                        [[258,525]]           1   \n48                                        [[279,546]]           1   \n49                                        [[258,525]]           1   \n50                                        [[264,531]]           1   \n51                                        [[258,525]]           1   \n52                                        [[279,546]]           1   \n53                                        [[258,525]]           1   \n54                                        [[243,510]]           1   \n\n       pdb_gap_list      unp_gap_list         var_list  repeated  var_0_count  \\\n0                []                []              [0]     False            1   \n1                []                []              [0]     False            1   \n2                []                []              [0]     False            1   \n3                []                []              [0]     False            1   \n4   [844,6,1,5,2,2]  [-229,0,0,0,0,0]  [0,1,0,0,0,1,0]      True            5   \n5             [158]               [0]            [0,0]     False            2   \n6   [844,6,1,5,2,2]  [-229,0,0,0,0,0]  [0,1,0,0,0,1,0]      True            5   \n7             [158]               [0]            [0,0]     False            2   \n8                []                []              [0]     False            1   \n9                []                []              [0]     False            1   \n10              [1]               [0]            [0,0]     False            2   \n11               []                []              [0]     False            1   \n12              [1]               [0]            [0,0]     False            2   \n13               []                []              [0]     False            1   \n14               []                []              [0]     False            1   \n15               []                []              [0]     False            1   \n16               []                []              [0]     False            1   \n17               []                []              [0]     False            1   \n18               []                []              [0]     False            1   \n19               []                []              [0]     False            1   \n20              [2]              [28]            [0,0]     False            2   \n21              [2]              [70]            [0,0]     False            2   \n22              [2]              [70]            [0,0]     False            2   \n23              [2]              [28]            [0,0]     False            2   \n24               []                []              [0]     False            1   \n25               []                []              [0]     False            1   \n26               []                []              [0]     False            1   \n27               []                []              [0]     False            1   \n28               []                []              [0]     False            1   \n29               []                []              [0]     False            1   \n30               []                []              [0]     False            1   \n31               []                []              [0]     False            1   \n32               []                []              [0]     False            1   \n33               []                []              [0]     False            1   \n34               []                []              [0]     False            1   \n35               []                []              [0]     False            1   \n36               []                []              [0]     False            1   \n37               []                []              [0]     False            1   \n38               []                []              [0]     False            1   \n39               []                []              [0]     False            1   \n40               []                []              [0]     False            1   \n41               []                []              [0]     False            1   \n42               []                []              [0]     False            1   \n43               []                []              [0]     False            1   \n44               []                []              [0]     False            1   \n45               []                []              [0]     False            1   \n46               []                []              [0]     False            1   \n47               []                []              [0]     False            1   \n48               []                []              [0]     False            1   \n49               []                []              [0]     False            1   \n50               []                []              [0]     False            1   \n51               []                []              [0]     False            1   \n52               []                []              [0]     False            1   \n53               []                []              [0]     False            1   \n54               []                []              [0]     False            1   \n\n    unp_gap_0_count  unp_pdb_var       sifts_range_tag  \\\n0                 0            0                  Safe   \n1                 0            0                  Safe   \n2                 0            0                  Safe   \n3                 0            0                  Safe   \n4                 5            0  Insertion & Deletion   \n5                 1            0             Insertion   \n6                 5            0  Insertion & Deletion   \n7                 1            0             Insertion   \n8                 0            0                  Safe   \n9                 0            0                  Safe   \n10                1            0             Insertion   \n11                0            0                  Safe   \n12                1            0             Insertion   \n13                0            0                  Safe   \n14                0            0                  Safe   \n15                0            0                  Safe   \n16                0            0                  Safe   \n17                0            0                  Safe   \n18                0            0                  Safe   \n19                0            0                  Safe   \n20                0            0  Insertion & Deletion   \n21                0            0  Insertion & Deletion   \n22                0            0  Insertion & Deletion   \n23                0            0  Insertion & Deletion   \n24                0            0                  Safe   \n25                0            0                  Safe   \n26                0            0                  Safe   \n27                0            0                  Safe   \n28                0            0                  Safe   \n29                0            0                  Safe   \n30                0            0                  Safe   \n31                0            0                  Safe   \n32                0            0                  Safe   \n33                0            0                  Safe   \n34                0            0                  Safe   \n35                0            0                  Safe   \n36                0            0                  Safe   \n37                0            0                  Safe   \n38                0            0                  Safe   \n39                0            0                  Safe   \n40                0            0                  Safe   \n41                0            0                  Safe   \n42                0            0                  Safe   \n43                0            0                  Safe   \n44                0            0                  Safe   \n45                0            0                  Safe   \n46                0            0                  Safe   \n47                0            0                  Safe   \n48                0            0                  Safe   \n49                0            0                  Safe   \n50                0            0                  Safe   \n51                0            0                  Safe   \n52                0            0                  Safe   \n53                0            0                  Safe   \n54                0            0                  Safe   \n\n                                        new_unp_range  \\\n0                                           [[1,184]]   \n1                                           [[1,184]]   \n2                                           [[1,118]]   \n3                                           [[1,118]]   \n4   [[2,379],[151,169],[170,176],[177,186],[187,19...   \n5                                [[2,503],[504,1177]]   \n6   [[2,379],[151,169],[170,176],[177,186],[187,19...   \n7                                [[2,503],[504,1177]]   \n8                                          [[2,1335]]   \n9                                          [[2,1335]]   \n10                                  [[1,43],[44,325]]   \n11                                          [[1,260]]   \n12                                  [[1,43],[44,325]]   \n13                                          [[1,260]]   \n14                                          [[1,326]]   \n15                                         [[20,210]]   \n16                                         [[20,210]]   \n17                                          [[1,326]]   \n18                                         [[1,2549]]   \n19                                         [[1,2549]]   \n20                                [[1,155],[182,317]]   \n21                                [[1,157],[226,359]]   \n22                                [[1,157],[226,359]]   \n23                                [[1,155],[182,317]]   \n24                                          [[2,147]]   \n25                                          [[2,147]]   \n26                                          [[2,142]]   \n27                                          [[2,142]]   \n28                                        [[264,531]]   \n29                                        [[258,525]]   \n30                                        [[243,510]]   \n31                                        [[279,546]]   \n32                                        [[258,525]]   \n33                                        [[243,510]]   \n34                                        [[243,510]]   \n35                                        [[258,525]]   \n36                                        [[279,546]]   \n37                                        [[264,531]]   \n38                                        [[264,531]]   \n39                                        [[258,525]]   \n40                                        [[279,546]]   \n41                                        [[264,531]]   \n42                                        [[243,510]]   \n43                                        [[243,510]]   \n44                                        [[279,546]]   \n45                                        [[258,525]]   \n46                                        [[264,531]]   \n47                                        [[258,525]]   \n48                                        [[279,546]]   \n49                                        [[258,525]]   \n50                                        [[264,531]]   \n51                                        [[258,525]]   \n52                                        [[279,546]]   \n53                                        [[258,525]]   \n54                                        [[243,510]]   \n\n                                        new_pdb_range  \n0                                           [[5,188]]  \n1                                           [[5,188]]  \n2                                           [[5,122]]  \n3                                           [[5,122]]  \n4   [[10,387],[1232,1249],[1256,1262],[1264,1273],...  \n5                               [[10,511],[670,1343]]  \n6   [[10,387],[1232,1249],[1256,1262],[1264,1273],...  \n7                               [[10,511],[670,1343]]  \n8                                         [[10,1343]]  \n9                                         [[10,1343]]  \n10                                  [[1,43],[45,326]]  \n11                                         [[67,326]]  \n12                                  [[1,43],[45,326]]  \n13                                         [[67,326]]  \n14                                          [[1,326]]  \n15                                          [[1,191]]  \n16                                          [[1,191]]  \n17                                          [[1,326]]  \n18                                         [[1,2549]]  \n19                                         [[1,2549]]  \n20                                [[1,155],[156,291]]  \n21                                [[1,157],[158,291]]  \n22                                [[1,157],[158,291]]  \n23                                [[1,155],[156,291]]  \n24                                          [[1,146]]  \n25                                          [[1,146]]  \n26                                          [[1,141]]  \n27                                          [[1,141]]  \n28                                         [[25,292]]  \n29                                         [[25,292]]  \n30                                         [[25,292]]  \n31                                         [[25,292]]  \n32                                         [[25,292]]  \n33                                         [[25,292]]  \n34                                         [[25,292]]  \n35                                         [[25,292]]  \n36                                         [[25,292]]  \n37                                         [[25,292]]  \n38                                         [[25,292]]  \n39                                         [[25,292]]  \n40                                         [[25,292]]  \n41                                         [[25,292]]  \n42                                         [[25,292]]  \n43                                         [[25,292]]  \n44                                         [[25,292]]  \n45                                         [[25,292]]  \n46                                         [[25,292]]  \n47                                         [[25,292]]  \n48                                         [[25,292]]  \n49                                         [[25,292]]  \n50                                         [[25,292]]  \n51                                         [[25,292]]  \n52                                         [[25,292]]  \n53                                         [[25,292]]  \n54                                         [[25,292]]  ",
      "text/html": "<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>UniProt</th>\n      <th>pdb_id</th>\n      <th>entity_id</th>\n      <th>chain_id</th>\n      <th>identity</th>\n      <th>pdb_range</th>\n      <th>unp_range</th>\n      <th>group_info</th>\n      <th>pdb_gap_list</th>\n      <th>unp_gap_list</th>\n      <th>var_list</th>\n      <th>repeated</th>\n      <th>var_0_count</th>\n      <th>unp_gap_0_count</th>\n      <th>unp_pdb_var</th>\n      <th>sifts_range_tag</th>\n      <th>new_unp_range</th>\n      <th>new_pdb_range</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>Q15382</td>\n      <td>6bcu</td>\n      <td>5</td>\n      <td>R</td>\n      <td>1.000000</td>\n      <td>[[5,188]]</td>\n      <td>[[1,184]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,184]]</td>\n      <td>[[5,188]]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>Q15382</td>\n      <td>6bcu</td>\n      <td>5</td>\n      <td>S</td>\n      <td>1.000000</td>\n      <td>[[5,188]]</td>\n      <td>[[1,184]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,184]]</td>\n      <td>[[5,188]]</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>Q13541</td>\n      <td>6bcu</td>\n      <td>4</td>\n      <td>Z</td>\n      <td>1.000000</td>\n      <td>[[5,122]]</td>\n      <td>[[1,118]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,118]]</td>\n      <td>[[5,122]]</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>Q13541</td>\n      <td>6bcu</td>\n      <td>4</td>\n      <td>X</td>\n      <td>1.000000</td>\n      <td>[[5,122]]</td>\n      <td>[[1,118]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,118]]</td>\n      <td>[[5,122]]</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>Q8N122-2</td>\n      <td>6bcu</td>\n      <td>3</td>\n      <td>Y</td>\n      <td>0.268817</td>\n      <td>[[10,387],[1232,1249],[1256,1262],[1264,1273],...</td>\n      <td>[[2,379],[151,169],[170,176],[177,186],[187,19...</td>\n      <td>7</td>\n      <td>[844,6,1,5,2,2]</td>\n      <td>[-229,0,0,0,0,0]</td>\n      <td>[0,1,0,0,0,1,0]</td>\n      <td>True</td>\n      <td>5</td>\n      <td>5</td>\n      <td>0</td>\n      <td>Insertion &amp; Deletion</td>\n      <td>[[2,379],[151,169],[170,176],[177,186],[187,19...</td>\n      <td>[[10,387],[1232,1249],[1256,1262],[1264,1273],...</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>Q8N122-3</td>\n      <td>6bcu</td>\n      <td>3</td>\n      <td>W</td>\n      <td>0.217391</td>\n      <td>[[10,511],[670,1343]]</td>\n      <td>[[2,503],[504,1177]]</td>\n      <td>2</td>\n      <td>[158]</td>\n      <td>[0]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>1</td>\n      <td>0</td>\n      <td>Insertion</td>\n      <td>[[2,503],[504,1177]]</td>\n      <td>[[10,511],[670,1343]]</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>Q8N122-2</td>\n      <td>6bcu</td>\n      <td>3</td>\n      <td>W</td>\n      <td>0.268817</td>\n      <td>[[10,387],[1232,1249],[1256,1262],[1264,1273],...</td>\n      <td>[[2,379],[151,169],[170,176],[177,186],[187,19...</td>\n      <td>7</td>\n      <td>[844,6,1,5,2,2]</td>\n      <td>[-229,0,0,0,0,0]</td>\n      <td>[0,1,0,0,0,1,0]</td>\n      <td>True</td>\n      <td>5</td>\n      <td>5</td>\n      <td>0</td>\n      <td>Insertion &amp; Deletion</td>\n      <td>[[2,379],[151,169],[170,176],[177,186],[187,19...</td>\n      <td>[[10,387],[1232,1249],[1256,1262],[1264,1273],...</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>Q8N122-3</td>\n      <td>6bcu</td>\n      <td>3</td>\n      <td>Y</td>\n      <td>0.217391</td>\n      <td>[[10,511],[670,1343]]</td>\n      <td>[[2,503],[504,1177]]</td>\n      <td>2</td>\n      <td>[158]</td>\n      <td>[0]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>1</td>\n      <td>0</td>\n      <td>Insertion</td>\n      <td>[[2,503],[504,1177]]</td>\n      <td>[[10,511],[670,1343]]</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>Q8N122</td>\n      <td>6bcu</td>\n      <td>3</td>\n      <td>W</td>\n      <td>0.190265</td>\n      <td>[[10,1343]]</td>\n      <td>[[2,1335]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[2,1335]]</td>\n      <td>[[10,1343]]</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>Q8N122</td>\n      <td>6bcu</td>\n      <td>3</td>\n      <td>Y</td>\n      <td>0.190265</td>\n      <td>[[10,1343]]</td>\n      <td>[[2,1335]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[2,1335]]</td>\n      <td>[[10,1343]]</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>Q9BVC4-5</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>E</td>\n      <td>0.996933</td>\n      <td>[[1,43],[45,326]]</td>\n      <td>[[1,43],[44,325]]</td>\n      <td>2</td>\n      <td>[1]</td>\n      <td>[0]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>1</td>\n      <td>0</td>\n      <td>Insertion</td>\n      <td>[[1,43],[44,325]]</td>\n      <td>[[1,43],[45,326]]</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>Q9BVC4-3</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>E</td>\n      <td>1.000000</td>\n      <td>[[67,326]]</td>\n      <td>[[1,260]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,260]]</td>\n      <td>[[67,326]]</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>Q9BVC4-5</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>D</td>\n      <td>0.996933</td>\n      <td>[[1,43],[45,326]]</td>\n      <td>[[1,43],[44,325]]</td>\n      <td>2</td>\n      <td>[1]</td>\n      <td>[0]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>1</td>\n      <td>0</td>\n      <td>Insertion</td>\n      <td>[[1,43],[44,325]]</td>\n      <td>[[1,43],[45,326]]</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>Q9BVC4-3</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>D</td>\n      <td>1.000000</td>\n      <td>[[67,326]]</td>\n      <td>[[1,260]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,260]]</td>\n      <td>[[67,326]]</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>Q9BVC4</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>E</td>\n      <td>1.000000</td>\n      <td>[[1,326]]</td>\n      <td>[[1,326]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,326]]</td>\n      <td>[[1,326]]</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>Q9BVC4-4</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>D</td>\n      <td>1.000000</td>\n      <td>[[1,191]]</td>\n      <td>[[20,210]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[20,210]]</td>\n      <td>[[1,191]]</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>Q9BVC4-4</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>E</td>\n      <td>1.000000</td>\n      <td>[[1,191]]</td>\n      <td>[[20,210]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[20,210]]</td>\n      <td>[[1,191]]</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>Q9BVC4</td>\n      <td>6bcu</td>\n      <td>2</td>\n      <td>D</td>\n      <td>1.000000</td>\n      <td>[[1,326]]</td>\n      <td>[[1,326]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,326]]</td>\n      <td>[[1,326]]</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>P42345</td>\n      <td>6bcu</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.976854</td>\n      <td>[[1,2549]]</td>\n      <td>[[1,2549]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,2549]]</td>\n      <td>[[1,2549]]</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>P42345</td>\n      <td>6bcu</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.976854</td>\n      <td>[[1,2549]]</td>\n      <td>[[1,2549]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[1,2549]]</td>\n      <td>[[1,2549]]</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>O00214</td>\n      <td>3vkl</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.371212</td>\n      <td>[[1,155],[158,291]]</td>\n      <td>[[1,155],[184,317]]</td>\n      <td>2</td>\n      <td>[2]</td>\n      <td>[28]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Insertion &amp; Deletion</td>\n      <td>[[1,155],[182,317]]</td>\n      <td>[[1,155],[156,291]]</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>O00214-2</td>\n      <td>3vkl</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.371212</td>\n      <td>[[1,155],[158,291]]</td>\n      <td>[[1,155],[226,359]]</td>\n      <td>2</td>\n      <td>[2]</td>\n      <td>[70]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Insertion &amp; Deletion</td>\n      <td>[[1,157],[226,359]]</td>\n      <td>[[1,157],[158,291]]</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>O00214-2</td>\n      <td>3vkl</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.371212</td>\n      <td>[[1,155],[158,291]]</td>\n      <td>[[1,155],[226,359]]</td>\n      <td>2</td>\n      <td>[2]</td>\n      <td>[70]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Insertion &amp; Deletion</td>\n      <td>[[1,157],[226,359]]</td>\n      <td>[[1,157],[158,291]]</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>O00214</td>\n      <td>3vkl</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.371212</td>\n      <td>[[1,155],[158,291]]</td>\n      <td>[[1,155],[184,317]]</td>\n      <td>2</td>\n      <td>[2]</td>\n      <td>[28]</td>\n      <td>[0,0]</td>\n      <td>False</td>\n      <td>2</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Insertion &amp; Deletion</td>\n      <td>[[1,155],[182,317]]</td>\n      <td>[[1,155],[156,291]]</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>P68871</td>\n      <td>1a01</td>\n      <td>2</td>\n      <td>D</td>\n      <td>0.986301</td>\n      <td>[[1,146]]</td>\n      <td>[[2,147]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[2,147]]</td>\n      <td>[[1,146]]</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>P68871</td>\n      <td>1a01</td>\n      <td>2</td>\n      <td>B</td>\n      <td>0.986301</td>\n      <td>[[1,146]]</td>\n      <td>[[2,147]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[2,147]]</td>\n      <td>[[1,146]]</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>P69905</td>\n      <td>1a01</td>\n      <td>1</td>\n      <td>A</td>\n      <td>1.000000</td>\n      <td>[[1,141]]</td>\n      <td>[[2,142]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[2,142]]</td>\n      <td>[[1,141]]</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>P69905</td>\n      <td>1a01</td>\n      <td>1</td>\n      <td>C</td>\n      <td>1.000000</td>\n      <td>[[1,141]]</td>\n      <td>[[2,142]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[2,142]]</td>\n      <td>[[1,141]]</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>P42684-10</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[264,531]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[264,531]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>P42684-6</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>30</th>\n      <td>P42684-2</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[243,510]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[243,510]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>31</th>\n      <td>P42684</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[279,546]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[279,546]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>32</th>\n      <td>P42684-7</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>33</th>\n      <td>P42684-4</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[243,510]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[243,510]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>34</th>\n      <td>P42684-4</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[243,510]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[243,510]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>35</th>\n      <td>P42684-7</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>36</th>\n      <td>P42684-5</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[279,546]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[279,546]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>37</th>\n      <td>P42684-3</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[264,531]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[264,531]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>38</th>\n      <td>P42684-10</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[264,531]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[264,531]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>39</th>\n      <td>P42684-6</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>40</th>\n      <td>P42684-5</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[279,546]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[279,546]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>41</th>\n      <td>P42684-3</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[264,531]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[264,531]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>42</th>\n      <td>P42684-2</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[243,510]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[243,510]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>43</th>\n      <td>P42684-2</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[243,510]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[243,510]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>44</th>\n      <td>P42684</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[279,546]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[279,546]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>45</th>\n      <td>P42684-8</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>46</th>\n      <td>P42684-10</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[264,531]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[264,531]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>47</th>\n      <td>P42684-8</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>48</th>\n      <td>P42684</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[279,546]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[279,546]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>49</th>\n      <td>P42684-8</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>C</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>50</th>\n      <td>P42684-3</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[264,531]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[264,531]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>51</th>\n      <td>P42684-6</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>52</th>\n      <td>P42684-5</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[279,546]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[279,546]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>53</th>\n      <td>P42684-7</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>B</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[258,525]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[258,525]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n    <tr>\n      <th>54</th>\n      <td>P42684-4</td>\n      <td>2xyn</td>\n      <td>1</td>\n      <td>A</td>\n      <td>0.992593</td>\n      <td>[[25,292]]</td>\n      <td>[[243,510]]</td>\n      <td>1</td>\n      <td>[]</td>\n      <td>[]</td>\n      <td>[0]</td>\n      <td>False</td>\n      <td>1</td>\n      <td>0</td>\n      <td>0</td>\n      <td>Safe</td>\n      <td>[[243,510]]</td>\n      <td>[[25,292]]</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 8
    }
   ],
   "source": [
    "%time\n",
    "get_ed_sifts_info(neo4j_api, lyst=['6bcu', '3vkl', '1a01', '2xyn'], id_type='pdb').result()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1-final"
  },
  "orig_nbformat": 2,
  "kernelspec": {
   "name": "python3",
   "display_name": "Python 3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}